# import pandas as pd
#
# # 统计CSV文件行数
# csv_files = [
#     r"H:\pycharmproject\data\抖音1.csv",
#     r"H:\pycharmproject\data\抖音2.csv",
#     r"H:\pycharmproject\data\抖音3.csv",
#     r"H:\pycharmproject\data\抖音4.csv"
# ]
#
# for file_path in csv_files:
#     df = pd.read_csv(file_path, encoding='utf-8')
#     print(f"{file_path} 数据量: {len(df)} 行")



import pandas as pd

# 统计Excel文件行数
excel_files = [
    r"H:\pycharmproject\data\抖音1.xlsx",
    r"H:\pycharmproject\data\抖音2.xlsx",
    r"H:\pycharmproject\data\抖音3.xlsx",
    r"H:\pycharmproject\data\抖音4.xlsx"
]

for file_path in excel_files:
    df = pd.read_excel(file_path)
    print(f"{file_path} 数据量: {len(df)} 行")
